package com.blog.cloud.controller.rec;

import java.io.BufferedReader;
import java.io.FileReader;

public class Test {
	
	
	public static void main(String[] args) throws Exception {
		/*int a = 3;
		Integer integer = 15/a;
		int[] indexArr = new int[a];
		for (int i = 0; i < a; i++) {
			if(i==0){
				indexArr[i] = integer; 
			}else{
				indexArr[i] = (i+1)*integer; 
			}
		}
		for (int i = 0; i < indexArr.length; i++) {
			System.out.println(indexArr[i]);
		}*/
		
		
		String path = "D:\\123.txt";

		
		
		
        FileReader fr=new FileReader(path);
        BufferedReader br=new BufferedReader(fr);
        String line="";
        String[] arrs=null;
        while ((line=br.readLine())!=null) {
           
            String[] split = line.split("@");
			int number = (int)((Math.random()*9+1)*1000);
			String sql = "INSERT INTO `lexy_tags` VALUES ('20171120183738"+number+"', '"+split[0].trim()+"', '"+split[1].trim()+"', '1', 'gallery', '201711111723538841', NULL, '0');";
			System.out.println(sql);
        }
        br.close();
        fr.close();
		
		
		
		
		
		
		
		
		
		
		
		
	}

}
